Drainage and Utilities CONNECT Edition Help

Editing FlexTables

You can edit a FlexTable to change the columns of data it contains or the values in some of those columns.

Editable columns

Columns that contain data you can edit are displayed with a white background. You can change these columns directly in the FlexTable and your changes are applied to your model when you click OK.The content in the FlexTable columns can be changed in other areas of Drainage and Utilities, such as in a Property Editor or managers; but, it might be more efficient to make changes to numerous elements in a FlexTable rather than the Property Editor or a manager.If you make a change that affects a FlexTable outside the FlexTable, the FlexTable is updated automatically to reflect the change.Non-editable columnsColumns that contain data you cannot edit are displayed with a yellow background, and correspond to model results calculated by the program and composite values.The content in these columns can be changed in other areas of Drainage and Utilities, such as in a Property Editor and by running a computation.If you make a change that affects a FlexTable outside the FlexTable, the FlexTable is updated automatically to reflect the change.

To edit a FlexTable:

  1. Click View > FlexTables to open the FlexTables Manager, then you can:
  2. The Table dialog box opens. .
  3. Use the Table dialog box to include and exclude columns and change the order in which the columns appear in the table.
  4. Click OK after you finish making changes, to save your changes and close the dialog box; or, click Cancel to close the dialog box without making changes.

Editing Column-Heading Text

To change the text of a column heading:

  1. Click View > FlexTables to open the FlexTables Manager.
  2. In the FlexTables manager, open the FlexTable you want to edit.
  3. Right-click the column heading and select Edit Column Label.
  4. Type the new name for the label and click OK to save those changes and close the dialog box or Cancel to exit without making any changes.

Changing Units, Format, and Precision in FlexTables

To change the units, format, or precision in a column of a FlexTable:

  1. Click View > FlexTables to open the FlexTables Manager.
  2. In the FlexTables manager, open the FlexTable you want to edit.
  3. Right-click the column heading and select Units.
  4. Make the changes you want and click OK to save those changes or Cancel to exit without making any changes.

Navigating in Tables

The arrow keys, Ctrl+Home, Ctrl+End, PgUp, PgDn, and Ctrl+arrow keys navigate to different cells in a table.

Globally Editing Data

Using FlexTables, you can globally edit all of the values in an entire editable column. Globally editing a FlexTable column can be more efficient for editing properties of an element than using the Properties Editor or managers to edit each element in your model individually.

To globally edit the values in a FlexTable column:

  1. Click View > FlexTables to open the FlexTables Manager.
  2. In the FlexTables manager, open the FlexTable you want to edit and find the column of data you want to change.
  3. If necessary, you might need to first create a FlexTable or edit an existing one to make sure it contains the column you want to change.
  4. Right-click the column heading and select Global Edit.
  5. In the Operation field, select what you want to do to data in the column: Add, Divide, Multiply, Set, or Subtract.The Operation field is only available for numeric data.
  6. In the Global Edit field, type or select the value you want—for numeric data, you typically type a new value, for other data you might select from a drop-down list or select a check box.